Q R ?Programming Assignment Development Feedback Remember, the weekly assignments in this course are intentionally complex. All of the skills and knowledge needed to complete the assignments has been woven into the course modules, but I am not teaching directly to the assignments. Instead, I am asking you to pull together the pieces of the puzzle which will help you solve the problem. It is important you DO NOT PROCRASTINATE.?I am here to support you, but timely feedback requires you to work proactively.? At any time during week 1, you may submit screenshots, draft files,?etc. along with?specific questions?related to the development of this assignment. The goal is not for me to "pre-grade" your work, but offer guidance?and point you in the right direction. I encourage you to make use of this opportunity to refine and develop your work. Refer to my?Instructor Introduction and the?Course Syllabus?for the best ways to contact me, in order to get feedback, and expected response times.? ________________________________________ Format and Submission For the purposes of this assignment, use R Studio. Your submission should have 2 files. The first file should be the R Script and it should be saved like "Project1_LastName_FirstName.R" (notice the .R as the file extension of the script). The second file should be a Microsoft Word file that documents your solutions with screenshots and provides any written responses to the questions below (if the question doesn't specifically request the responses to be within the comments of the code). Both files are mandatory. You don't need individual screenshots for each question, but your screenshots should cover all questions. ________________________________________ Assignment Scenario and Tasks ***NOTE: For each question make sure that your work is not repeating something in the course modules or the textbook. Each response must be original and your own submission. You are strictly prohibited from having another person(s) write, review or edit your solution. Failure to follow this may result in a failing grade. You are a data scientist in Awesome Insurance Analytics (AIA). AIA is a public company traded in Stock exchange focus on consulting on auto insurance. It is well known that full coverage car insurance is more expensive than the liability only insurance.To choose the cheapest car insurance rates at different states, you are given a data set containing the average annual premiums from available carriers. Data Source: https://www.nerdwallet.com/blog/insurance/best-cheap-car-insurance/ (Links to an external site.) This data set contains the following columns: State: The list of states of the United States MRC: The average annual price of minimum required coverage FC: The average annual price of full coverage AD: The annual price differences of minimum required coverage and full coverage You are asked to perform the following tasks by writing a script in R and submit both R codes and a Word document. 1. Read the dataset in CarInsurances.xlsx Download CarInsurances.xlsxinto R. Call the loaded data Insurance. Make sure that you have the directory set to the correct location for the data. 2. How many rows in the data set? What do the rows represent? 3. How many columns in the data set? What do the columns represent? 4. Assign the first eight rows of the data set to a variable: first.eight.rows and print it out using print() function. 5. Assign the last five rows of the data set to a variable: five.rows and print it out using print() function. 6. List all objects in the memory using two methods. 7. We want to summarize the data. To do it, we may use the summary function. Before asking others for help, it’s generally a good idea for you to try to help yourself either using help() function or google it. Please help yourself and summarize the data first. Then answer the following questions: 7.1. What is the mean of MRC (annual premium of Minimum Required Coverage)? 7.2 What is the mean of FC (annual premium of Full Coverage)? 7.3 What is the mean of AD (annual premium differences between MRC and FC)? View Rubric Projects Rubric Projects Rubric Criteria Ratings Pts R Codes and Style view longer description 15 pts Excellent R codes are easier to read, share, and verify. There are comments in the codes. There are no bugs in the script. 12 pts Good R codes ae easier to read, share, and verify. There are few comments. There are less than 3 bugs in the script. 9 pts Average R codes could be read. There is no comment. There are less than 4 bugs in the script. 6 pts Below Average R codes are hard to read. There is no comment. There are more than 5 bugs in the script. 3 pts Insufficient R codes are hard to read. There are no comments. There are more than 5 bugs in the script. / 15 pts Interpretation and Use of Model in the Word Document view longer description 10 pts Excellent The data and model is accurately interpreted to justify the answer, and sufficient data and model is used to defend the main argument. 8 pts Good The data and model is accurately interpreted to justify the answer, and model is used to defend the main argument, but it might not be sufficient. 6 pts Average Data and model is used to defend the main argument, but does not accurately interpret the idea and model, and it might not be sufficient. 4 pts Below Average Data and model is used to defend the main argument, but it is insufficient. 2 pts Insufficient Data and model is provided, but it is not used to defend the main argument. / 10 pts Total Points: 0